package com.zbkj.crmeb.export.vo;

import lombok.Data;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.math.BigDecimal;

@Data
@Accessors(chain = true)
public class LogisticsExcelVo implements Serializable {

    @ExcelColumn(value = "订单状态", col = 1)
    private String orderStatus;

    @ExcelColumn(value = "订单号", col = 2)
    private String orderNumber;

    @ExcelColumn(value = "所属商户", col = 3)
    private String merName;

    @ExcelColumn(value = "商品订单号", col = 4)
    private String childOrderNumber;

    @ExcelColumn(value = "商品ID", col = 5)
    private Integer productId;

    @ExcelColumn(value = "商品名", col = 6)
    private String productName;

    @ExcelColumn(value = "品牌", col = 7)
    private String brandName;

    @ExcelColumn(value = "缩略图", col = 8)
    private String image;

    @ExcelColumn(value = "国际编码", col = 9)
    private String keyword;

    @ExcelColumn(value = "色号", col = 10)
    private String colorCode;

    @ExcelColumn(value = "尺码", col = 11)
    private String size;

    @ExcelColumn(value = "数量", col = 12)
    private Integer quantity;

    @ExcelColumn(value = "实际成本价（元）", col = 13)
    private BigDecimal actualCost;

    @ExcelColumn(value = "实际成本价（欧元）", col = 13)
    private BigDecimal actualCostEur;

    @ExcelColumn(value = "实际供应商", col = 14)
    private String actualSupplierName;

    @ExcelColumn(value = "实际发货地", col = 15)
    private String actualTempName;

    @ExcelColumn(value = "售价（元）", col = 16)
    private BigDecimal price;

    @ExcelColumn(value = "头程运费（元）", col = 17)
    private BigDecimal firstPrice;

    @ExcelColumn(value = "终端运费（元)", col = 18)
    private BigDecimal secondPrice;

    @ExcelColumn(value = "税费（元）", col = 19)
    private BigDecimal taxPrice;

    @ExcelColumn(value = "采购商订单号", col = 20)
    private String buyerOrderNo;

    @ExcelColumn(value = "海外直邮物流商", col = 21)
    private String odmLogistics;

    @ExcelColumn(value = "发货时间", col = 22)
    private String odmTime;

    @ExcelColumn(value = "海外直邮运单号", col = 23)
    private String odmOrderNo;

    @ExcelColumn(value = "海外发往中转仓物流商", col = 24)
    private String otwLogistics;

    @ExcelColumn(value = "发货时间", col = 25)
    private String otwTime;

    @ExcelColumn(value = "海外发往中转仓运单号", col = 26)
    private String otwOrderNo;

    @ExcelColumn(value = "中转仓发出物流商", col = 27)
    private String twdLogistics;

    @ExcelColumn(value = "发货时间", col = 28)
    private String twdTime;

    @ExcelColumn(value = "中转仓发出运单号", col = 29)
    private String twdOrderNo;

    @ExcelColumn(value = "清关中物流商", col = 30)
    private String clearanceLogistics;

    @ExcelColumn(value = "发货时间", col = 31)
    private String clearanceTime;

    @ExcelColumn(value = "清关中运单号", col = 32)
    private String clearanceOrderNo;

    @ExcelColumn(value = "国内派送物流商", col = 33)
    private String domesticLogistics;

    @ExcelColumn(value = "发货时间", col = 34)
    private String domesticTime;

    @ExcelColumn(value = "国内派送运单号", col = 35)
    private String domesticOrderNo;

    @ExcelColumn(value = "清关异常物流商", col = 36)
    private String abnormalClearanceLogistics;

    @ExcelColumn(value = "发货时间", col = 37)
    private String abnormalClearanceTime;

    @ExcelColumn(value = "清关异常运单号", col = 38)
    private String abnormalClearanceOrderNo;

    @ExcelColumn(value = "收货人", col = 40)
    private String realName;

    @ExcelColumn(value = "手机号", col = 41)
    private String userPhone;

    @ExcelColumn(value = "收货地址", col = 42)
    private String detail;

    @ExcelColumn(value = "身份证号", col = 43)
    private String idCard;

    @ExcelColumn(value = "季度", col = 44)
    private String seasonCode;

    @ExcelColumn(value = "国际运费（元）", col = 39)
    private BigDecimal taxInternationalPrice;
    @ExcelColumn(value = "转国内运费（元）", col = 39)
    private BigDecimal taxTurnInlandPrice;
    @ExcelColumn(value = "国内派送费（元）", col = 39)
    private BigDecimal taxInlandDeliveryPrice;
    @ExcelColumn(value = "税金（元）", col = 39)
    private BigDecimal taxTaxesPrice;
    /**
     * 运税费求和
     */
    @ExcelColumn(value = "实际运税费（元）", col = 39)
    private BigDecimal actualTaxAndSecondPrice;
}